package com.example.boot1.mapper;

import com.example.boot1.bean.VueCuisine;
import com.example.boot1.bean.VuePeiCuisineBean;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface VueCuisineMapper {
    /**
     * delete by primary key
     * @param id primaryKey
     * @return deleteCount
     */
    int deleteByPrimaryKey(Integer id);

    /**
     * insert record to table
     * @param record the record
     * @return insert count
     */
    int insert(VueCuisine record);

    /**
     * insert record to table selective
     * @param record the record
     * @return insert count
     */
    int insertSelective(VueCuisine record);

    /**
     * select by primary key
     * @param id primary key
     * @return object by primary key
     */
    VueCuisine selectByPrimaryKey(Integer id);

    /**
     * update record selective
     * @param record the updated record
     * @return update count
     */
    int updateByPrimaryKeySelective(VueCuisine record);

    /**
     * update record
     * @param record the updated record
     * @return update count
     */
    int updateByPrimaryKey(VueCuisine record);

    List<VueCuisine> findByName(String name);

    List<VueCuisine> getAllCuisine(Integer page);

    int findAllTotal();

    List<VueCuisine> findByIdAndName(@Param("id")Integer id, @Param("name")String name);


    List<VuePeiCuisineBean> findBySaleTop10();

}